<!doctype HTML public "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- Click to Convert 5.2: Anything to HTML -->
<!-- http://www.clicktoconvert.com -->

<html>
<head>
<title>gravityboxscheduleuserguide - page 66 of 234</title>
<meta http-equiv=content-type content=text/html;charset=iso-8859-1>
<meta name="Generator" content="Click to Convert">

<!--Start of page styles-->
<STYLE TYPE="text/css">
<!--
 /* Foreground Image Styles */

 /* Position Styles */
 .ts66p0{position:absolute;left:106px;top:97px;}
 .ts66p1{position:absolute;left:352px;top:97px;}
 .ts66p3{position:absolute;left:672px;top:97px;}
 .ts66p7{position:absolute;left:106px;top:113px;}
 .ts66p8{position:absolute;left:706px;top:1026px;}
 .ts66p9{position:absolute;left:331px;top:1044px;}
 .ts66p13{position:absolute;left:106px;top:147px;}
 .ts66p15{position:absolute;left:106px;top:165px;}
 .ts66p16{position:absolute;left:106px;top:183px;}
 .ts66p18{position:absolute;left:106px;top:201px;}
 .ts66p20{position:absolute;left:106px;top:220px;}
 .ts66p22{position:absolute;left:106px;top:238px;}
 .ts66p23{position:absolute;left:106px;top:256px;}
 .ts66p25{position:absolute;left:106px;top:274px;}
 .ts66p26{position:absolute;left:106px;top:293px;}
 .ts66p27{position:absolute;left:154px;top:293px;}
 .ts66p28{position:absolute;left:106px;top:311px;}
 .ts66p29{position:absolute;left:106px;top:329px;}
 .ts66p31{position:absolute;left:106px;top:348px;}
 .ts66p32{position:absolute;left:106px;top:366px;}
 .ts66p33{position:absolute;left:106px;top:385px;}
 .ts66p35{position:absolute;left:106px;top:403px;}
 .ts66p37{position:absolute;left:106px;top:421px;}
 .ts66p38{position:absolute;left:106px;top:440px;}
 .ts66p39{position:absolute;left:106px;top:458px;}
 .ts66p40{position:absolute;left:106px;top:477px;}
 .ts66p42{position:absolute;left:106px;top:495px;}
 .ts66p43{position:absolute;left:106px;top:513px;}
 .ts66p44{position:absolute;left:106px;top:532px;}

 /* Font Styles */
 .ft0p66{font-style:normal;font-weight:bold;font-size:13px;font-family:arial,sans-serif;color:#000000;}
 .ft1p66{font-weight:normal;}
 .ft2p66{font-style:normal;font-weight:normal;font-size:13px;font-family:"times new roman","times new roman",times,serif;color:#000000;}
 .ft3p66{font-style:normal;font-weight:normal;font-size:16px;font-family:"times new roman","times new roman",times,serif;color:#000000;}
 .ft4p66{font-style:normal;font-weight:bold;font-size:11px;font-family:arial,sans-serif;color:#000000;}
 .ft5p66{font-style:normal;font-weight:normal;font-size:16px;font-family:"courier new",courier,monospace;color:#000000;}
 .ft6p66{font-family:arial,sans-serif;}
 .ft7p66{font-style:normal;font-weight:normal;font-size:16px;font-family:arial,sans-serif;color:#000000;}

 /* Background Style */
 .styleBackground66{position:absolute;left:97px;top:145px}

 /* Navigation Styles */
 .styleNavBarTop{position:absolute;left:0px;top:2px}
 .nb{position:absolute;left:2px;top:0px}
 .nbs{position:absolute;left:0px;top:0px}
 .nbe{position:absolute;left:836px;top:0px}
 .styleNavBarBot{position:absolute;left:0px;top:1117px}
-->
</STYLE>
<!--End of page styles-->

</head>
<body bgcolor="#ffffff" text="#000000" link="#0000FF" Vlink="#660099">

<table id="pageTable" width="836" STYLE="position: relative; left: auto; top: auto;"><tr><td>
<div class=nbs><img src="./navbarstart.gif" width="2" height="30"></div>
<div class=nb><img src="./navbar.gif" width="836" height="30" alt="Navigation bar"></div>
<div class=nbe><img src="./navbarend.gif" width="2" height="30"></div>
<div class=styleNavBarTop>
<table width="834" height="26" border="0" cellspacing="0">
  <tr align="left">
    <td width="4">&nbsp;</td>
    <td width="25" align="center"><a href="http://www.gravitybox.com" target="_parent"><img src="./home.gif" border="0" alt="Home"></a></td>
    <td width="25" align="center"><a href="#" onClick="window.open('./print.html','Printing','width=300,height=100,toolbar=no,directories=no');return false;"><img src="./print.gif" border="0" alt="Print document"></a></td>
    <td width="10" align="center"><img src="./separator.gif" border="0"></td>
    <td width="18" align="center"><a href="./index1.html"><img src="./start.gif" width="18" height="14" border="0" alt="Start"></a></td>
    <td width="18" align="center"><a href="./index65.html"><img src="./back.gif" width="14" height="14" border="0" alt="Previous page"></a></td>
    <td width="80" valign="middle"><table width="100%" height="16" border="0" cellspacing="1" bgcolor="#ACA899"><tr><td align="center" bgcolor="#ffffff"><font face=verdana,arial,sans-serif><font size="1">&nbsp;66 of 234&nbsp;</font></font></td></tr></table></td>
    <td width="18" align="center"><a href="./index67.html"><img src="./forward.gif" width="14" height="14" border="0" alt="Next page"></a></td>
    <td width="18" align="center"><a href="./index234.html"><img src="./end.gif" width="18" height="14" border="0" alt="End"></a></td>
    <td width="620">&nbsp;</td>
  </tr>
</table>
<p>
</div>
<nobr>
<div class=styleBackground66><img src="./background66.png" width="633" height="910" border="0" alt=""></div>
<div class=ts66p0><span class="ft0p66"> </span></div>
<div class=ts66p1><span class="ft0p66">Gravitybox Schedule Primer<span class="ft1p66"> </span></span></div>
<div class=ts66p3><span class="ft0p66">Page 64&nbsp; </span></div>
<div class=ts66p7><span class="ft2p66"> </span></div>
<div class=ts66p8><span class="ft3p66"> </span></div>
<div class=ts66p9><span class="ft4p66">1998&#45;2004 Gravitybox Software LLC<span class="ft3p66"> </span></span></div>
<div class=ts66p13><span class="ft5p66">&nbsp; Next i </span></div>
<div class=ts66p15><span class="ft5p66"> </span></div>
<div class=ts66p16><span class="ft5p66">&nbsp; 'Deallocate objects </span></div>
<div class=ts66p18><span class="ft5p66">&nbsp; Call Db.Close </span></div>
<div class=ts66p20><span class="ft5p66">&nbsp; Set Db = Nothing </span></div>
<div class=ts66p22><span class="ft5p66"> </span></div>
<div class=ts66p23><span class="ft5p66">End Sub<span class="ft6p66"> </span></span></div>
<div class=ts66p25><span class="ft7p66"> </span></div>
<div class=ts66p26><span class="ft7p66"> </span></div>
<div class=ts66p27><span class="ft7p66">The Categories screen is setup in a very similar way. This only difference being </span></div>
<div class=ts66p28><span class="ft7p66">that it has the extra property of &#147;Color&#148; defined. The loading and saving of the </span></div>
<div class=ts66p29><span class="ft7p66">categories is almost identical. Though not a part of this database example, a Providers </span></div>
<div class=ts66p31><span class="ft7p66">collection could also be defined similarly. Each ScheduleItem on the schedule has a </span></div>
<div class=ts66p32><span class="ft7p66">&#147;Provider&#148; property that may be mapped to an element in the schedule&#146;s &#147;Providers&#148; </span></div>
<div class=ts66p33><span class="ft7p66">collection. This is used to define a set of people associated with a schedule. They too </span></div>
<div class=ts66p35><span class="ft7p66">may have a related color, that displays in the appointment&#146;s left margin, if need be.&nbsp; </span></div>
<div class=ts66p37><span class="ft7p66"> </span></div>
<div class=ts66p38><span class="ft7p66">This concludes the database example. There are many ways to implement this </span></div>
<div class=ts66p39><span class="ft7p66">functionality. The proposed methods are only guidelines. There are schemes that differ </span></div>
<div class=ts66p40><span class="ft7p66">in complexity but accomplish the same task: database saves and loads. This was </span></div>
<div class=ts66p42><span class="ft7p66">simple scheme and may not scale well. However for most applications there may be no </span></div>
<div class=ts66p43><span class="ft7p66">advantage to spending countless weeks optimizing convoluted algorithms. Then again </span></div>
<div class=ts66p44><span class="ft7p66">may be there will be for your situation. </span></div>
<div class=styleNavBarBot>
<table width="836" border="0" cellspacing="2">
  <tr></tr>
  <tr>
    <td width="118"><a href="http://www.purepage.com"><img src="./smalllogo.gif" width="118" height="46" border="0" alt="http://www.purepage.com"></a></td>
    <td></td>
  </tr>
</table>
</div>

</td></tr></table>

</body>
</html>
